﻿<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<!-- saved from url=(0029)http://www.helpandmanual.com/ -->
<head> 
   <title>Overview</title> 
   <!-- Template design (c) copyright 2008-2009 by Tim Green and EC Software -->
   <meta name="generator" content="Help &amp; Manual" /> 
   <meta name="keywords" content="" />
   <meta name="description" content="Overview" />
   <meta name="copyright" content="© 2012 Kentico Software" /> 
   <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> 
   <meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" />
   <link type="text/css" href="default.css" rel="stylesheet" /> 
   <link type="text/css" href="custom.css" rel="stylesheet" />

   <script type="text/javascript" src="jquery-1.3.2.min.js"></script>
   <script type="text/javascript" src="jquery.scrollTo-min.js"></script>
   <script type="text/javascript" src="nsh.js"></script>



         
   <!-- CSS set with project variables and local attributes --> 
   <style type="text/css" media="screen"> 
   body { background: #fff; } 
   #breadcrumbs {width: 100%; background-color: white; border-bottom: 1px solid #000; padding: 0px 0px 5px 15px;
   margin: 3px 0; font-size: 8pt; color: #000;}
   #breadcrumbs a { color: #000; text-decoration: none;}
   #breadcrumbs a:visited { color: #000; }
   #breadcrumbs a:hover { color: #098ae2; text-decoration: none; }
   .help-url { font-size: 10pt; font-family: Arial, Verdana, Helvetica, sans-serif; 
               color: #1f84e8; text-align: center; margin: 5px 20px 10px 0px; 
               padding-top: 14px; border-top: 1px solid #000;}
   .help-url a { color: #098ae2; text-decoration: none; }
   .help-url a:visited { color: #098ae2; }
   .help-url a:hover { color: #098ae2; text-decoration: underline; }
   .highlight {background: #ffff40;}
   .breadhead {padding: 5px 0px 0px 0px !important;}    
   #innerdiv   
   {   
   padding-left: 5px;
   }
   

   </style> 

<!-- Adjustment for IE -->
<!--[if lte IE 8]>
<style type="text/css">
.topichead { padding-right: 0; }
   
   
   	.breadhead {
	margin: 0;
	padding-right: 5px;
	}
   
   
</style>
<![endif]-->
   
<script type="text/javascript">
// Initialize the page 
addEvent(window, "load", nsrInit);
addEvent(window, "load", doResize);
addEvent(window, "resize", doResize);
addEvent(window, "load", toggleJump);

</script>


<script type="text/javascript">
function mailFB_custom() {
var headerText = unQuot("Feedback on: Kentico CMS 6.0 Context Help - Overview".replace('&nbsp;',''));
var fb1 = "mailto:" + escape('Kentico Support Team <support@kentico.com>') + "?subject=" + headerText;
var titlePath = unQuot("CMS Site Manager &gt; Development &gt; Custom tables &gt; Overview /");
var fb2 = "&body=Ref:%20" + titlePath + "%20ID:%20development_custom_tables_overview%0A%0D%0A%0D" + unQuot("Dear Support Staff,") + "%0A%0D%0A%0D";
var fb = fb1 + fb2;
document.location.href=fb;
}
</script>
<script type="text/javascript">

  var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-105987-4']);
  _gaq.push(['_setDomainName', '.kentico.com']);
  _gaq.push(['_trackPageview']);

  (function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  })();

</script>        
<script type="text/javascript" src="helpman_topicinit.js"></script>
<!-- Redirect browser to frame page if page is not in the content frame. -->
<script type="text/javascript">
<!--
if (location.search.lastIndexOf("toc=0")<=0) {
  if (parent.frames.length==0) { parent.location.href="index.html?development_custom_tables_overview.htm"; }
  else { parent.quicksync('a2.4.6.1'); }
}
//-->
</script>
<script type="text/javascript" src="highlight.js"></script></head> 
<body onload="highlight();">
<div id="hmpopupDiv" style="visibility:hidden; position:absolute; z-index:1000; "></div>
<!--ZOOMSTOP-->

<div id="printheader">
<span id="printtitle">Kentico CMS 6.0 Context Help</span><br />
<p class="p_Heading1"><span class="f_Heading1">Overview</span></p>
</div>
<div id="idheader" style="border-bottom:1px solid #000;margin:0px 0px;"> 
<table id="breadtable" border="0" cellspacing="0" cellpadding="0" width="100%"> 
  <tr >
  <td align="left" class="breadhead" >
       <p id="breadcrumbs"><a href="mode_selection.htm"
        onmouseover="document.images.main.src='home_h.gif'" 
        onmouseout="document.images.main.src='home.gif'">
        <img name="main" src="home.gif" border="0" alt="Home topic" title="Home topic" /></a> 
        
        CMS Site Manager &gt; <a href="development.htm">Development</a> &gt; Custom tables:</p> 
  </td>
  </tr>
</table>
<table width="99%" border="0" cellspacing="0" cellpadding="0" id="headtable"> 

<!-- Script version of NavHeader -->
  <tr id="scriptNavHead" valign="middle" style="height: auto;"> 
    <td align="left" class="topichead" style="padding-left: 15px;"> 
    <p class="p_Heading1"><span class="f_Heading1">Overview</span></p>

    </td>
    <td align="center" width="20" class="idnav" valign="bottom">
     <a href="custom_settings_main.htm"
        onmouseover="document.images.prev.src='button_prev_h.gif'" 
        onmouseout="document.images.prev.src='button_prev.gif'">
        <img name="prev" src="button_prev.gif" border="0" alt="Previous topic" title="Previous topic" /></a>
     
   </td>
   
   <td align="center" width="20" class="idnav" valign="bottom">
     <a href="custom_tables_list.htm"
        onmouseover="document.images.next.src='button_next_h.gif'" 
        onmouseout="document.images.next.src='button_next.gif'"><img name="next" src="button_next.gif" border="0" alt="Next topic" title="Next topic" /></a>
        
   </td>

   
   
   
   
   

     
   <td id="print-button" align="center" width="20" class="idnav" valign="bottom">
     <a href="javascript: print();" 
     onmouseover="document.images.printbutton.src='print_h.gif'" 
     onmouseout="document.images.printbutton.src='print.gif'"><img name="printbutton" border="0" alt="Print this topic" title="Print this topic" src="print.gif" /></a>
   </td>  
     
     

  
   <td id="mail-feedback" align="center" width="20" class="idnav" valign="bottom">
   <a href="#"
        onclick='mailFB_custom();'
        onmouseover="document.images.feedback.src='mail_h.gif'" 
        onmouseout="document.images.feedback.src='mail.gif'"><img name="feedback" src="mail.gif" border="0" alt="Mail us feedback on this topic!" title="Mail us feedback on this topic!" /></a>
   </td>
   
   <td width="4">&nbsp;</td>
  </tr>
<!-- End script navheader version -->

<!-- NoScript version of navheader -->

  <tr id="noScriptNavHead" valign="middle" style="height: auto;"> 
    <td align="left" class="topichead"> 
    <p class="p_Heading1"><span class="f_Heading1">Overview</span></p>

    </td>
    <td align="center" width="20" class="idnav" valign="bottom">
     <a href="custom_settings_main.htm">
        <img src="button_prev.gif" border="0" alt="Previous topic" title="Previous topic" /></a>
     
   </td>
   
   <td align="center" width="20" class="idnav" valign="bottom">
     <a href="custom_tables_list.htm">
        <img src="button_next.gif" border="0" alt="Next topic" title="Next topic" /></a>
        
   </td>
   
   
   
  
   

     
     
   <td align="center" width="20" class="idnav" valign="bottom">
   <img border="0" alt="JavaScript is required for the print function" title="JavaScript is required for the print function" src="print_d.gif" />
   </td>
     
     
   
   <td align="center" width="20" class="idnav" valign="bottom">
   <a href="mailto:support@kentico.com?subject=Documentation%20feedback&body=Ref%20ID:%20development_custom_tables_overview%0D%0D"><img src="mail.gif" border="0" alt="Mail us feedback on this topic!" title="Mail us feedback on this topic!" /></a>
   </td>
   
   <td width="4">&nbsp;</td>
  </tr>

<!-- End noscript navheader version -->
  </table>
<div id="autoTocWrapper"></div>
</div> 

<div id="idcontent"><div id="innerdiv">
<!--ZOOMRESTART-->
<p>The Custom tables module allows users to create their own tables in the system database and manage data in them via Kentico CMS user interface, without the need to use Microsoft SQL Server Management Studio or any other database management tool. This may come in handy in many scenarios, typically when you need to store a large number of structured data items, for which standard Kentico CMS documents are not efficient. Another typical scenario may be development of your custom modules, as you can store module data in custom tables and access them conveniently from your code using the provided API.</p>
<p>&nbsp;</p>
<p>User interface of the module can be found at two locations, while each of them is intended for different purposes. Custom tables themselves can be created and managed in <span style="font-weight: bold;">Site Manager -&gt; Development -&gt; Custom tables</span>. This section is intentionally located in Site Manager, so that only global administrators can create the tables. <a href="http://devnet.kentico.com/docs/6_0/devguide/Creating_custom_tables.htm" target="_blank" class="weblink">Developer's Guide -&gt; Modules -&gt; Custom tables -&gt; Creating custom tables</a> topic describes creation of custom tables by means of the <span style="font-weight: bold;">New custom table wizard</span>, which is accessible from this part of the user interface. Once a custom table is created, its configuration (not the actual data stored in it) can be managed in the same section of the user interface, as described in the <a href="http://devnet.kentico.com/docs/6_0/devguide/managing_custom_tables.htm" target="_blank" class="weblink">Managing custom tables</a> topic in the same chapter of the Developer's Guide.</p>
<p>&nbsp;</p>
<p>The other user interface related to this module can be found in <span style="font-weight: bold;">CMS Desk -&gt; Tools -&gt; Custom tables</span>. This is where new data records can be inserted into the tables and where existing data records can be viewed, modified or deleted. It is located in CMS Desk, so that manipulation with data in custom tables is available to content editors with appropriate permissions, as described in the <a href="http://devnet.kentico.com/docs/6_0/devguide/custom_tables_security.htm" target="_blank" class="weblink">Security</a> topic. Management of the actual data items is described in <a href="http://devnet.kentico.com/docs/6_0/devguide/Managing_data_in_custom_tables.htm" target="_blank" class="weblink">Managing data in custom tables</a>.</p>
<p>&nbsp;</p>
<p>The module comes with three web parts that can display data from custom tables on the live site. They are described in the <a href="http://devnet.kentico.com/docs/6_0/devguide/custom_tables_available_web_parts.htm" target="_blank" class="weblink">Available web parts</a> topic. Use of transformations is essential with these web parts, so we have prepared the <a href="http://devnet.kentico.com/docs/6_0/devguide/Transformations_for_custom_tables.htm" target="_blank" class="weblink">Transformations for custom tables</a> topic. There, you can find information on how to modify the default transformations in order to change the way the data items are displayed.</p>
<p>&nbsp;</p>
<p>Finally, the module comes with an API, which enables you to handle custom table data in your custom code. Code examples, along with a list of database tables and API classes related to the module, can be found in the <a href="http://devnet.kentico.com/docs/6_0/devguide/Custom_tables_Database_tables_and_API_classes.htm" target="_blank" class="weblink">Custom tables internals and API</a> sub-chapter.</p>
<p>&nbsp;</p>
<p>The Custom tables module interacts with two other Kentico CMS modules. Data stored in the tables can be searched using the <a href="http://devnet.kentico.com/docs/6_0/devguide/smart_search_overview.htm" target="_blank" class="weblink">Smart search</a> module. You can also create <a href="http://devnet.kentico.com/docs/6_0/devguide/Alternative_forms_module_overview.htm" target="_blank" class="weblink">Alternative forms</a> for the tables. These forms can be used instead of the default forms for creating or editing a custom table in the administration interface, as described in <a href="http://devnet.kentico.com/docs/6_0/devguide/Automatically_used_alternative_forms.htm" target="_blank" class="weblink">Developer's Guide -&gt; Modules -&gt; Alternative forms -&gt; Automatically used alternative forms</a>.</p>
<p>&nbsp;</p>

<!--ZOOMSTOP--> 

<noscript>
<p class="help-url"><b>Help URL:&nbsp;</b><a href="<%HELP_LOCATION%><%DEVNET_PATH_NAME%>/index.html?development_custom_tables_overview.htm" target="_top" title="Right-click to copy the URL of this help topic">
<%HELP_LOCATION%><%DEVNET_PATH_NAME%>/index.html?development_custom_tables_overview.htm</a>
</p>
</noscript>
<script type="text/javascript">
var autoURL = true;
if (autoURL) {
      document.write(getHref("index.html","Help URL:","Right-click to copy the URL of this help topic"));
      } else {
             document.write('<p class="help-url"><b>Help URL:&nbsp;</b>');
             document.write('<a href="<%HELP_LOCATION%><%DEVNET_PATH_NAME%>/index.html?development_custom_tables_overview.htm" target="_top" title="Right-click to copy the URL of this help topic"><%HELP_LOCATION%><%DEVNET_PATH_NAME%>/index.html?development_custom_tables_overview.htm</a>');
             document.write('</p>');
      }
</script>

</div></div> 
</body>
</html>





